Multi-Level Queries Can Make MS Access a Powerful Tool for SMEs
نویسندگان
چکیده
This paper demonstrates the power of multi-level queries in MS Access, showing how they may be used to generate an indented Bill of Material without recourse to programming code (such as Visual Basic). The development took place in an SME that specialises in providing ultrasonic solutions to industrial problems. The generating of indented BOMs was one part of a project to provide a costing system for their assembled products.
منابع مشابه
A Method for Protecting Access Pattern in Outsourced Data
Protecting the information access pattern, which means preventing the disclosure of data and structural details of databases, is very important in working with data, especially in the cases of outsourced databases and databases with Internet access. The protection of the information access pattern indicates that mere data confidentiality is not sufficient and the privacy of queries and accesses...
متن کاملDeveloping a BIM-based Spatial Ontology for Semantic Querying of 3D Property Information
With the growing dominance of complex and multi-level urban structures, current cadastral systems, which are often developed based on 2D representations, are not capable of providing unambiguous spatial information about urban properties. Therefore, the concept of 3D cadastre is proposed to support 3D digital representation of land and properties and facilitate the communication of legal owners...
متن کاملMulti-stage Mass Spectrometry up to MS4 on a QTof System
K E Y W O R D S T-WaveTM ion mobility, IMS, MS, MS, structure elucidation A P P L I C AT IO N B E N E F I T S This application note illustrates how multi-stage mass spectra up to MS can be generated on a SYNAPT G2 HDMS System in a single experiment. This experiment avoids the need to trigger on, isolate, and fragment specific ions, as is done in directed MS methods. Moreover, the duty cycle rem...
متن کاملUsing Relationship Roles to Disambiguate Conceptual-Level Queries
QUICK is a powerful database query tool used to simplify database access. It allows users and applications to formulate high-level queries to relational databases without specifying information about the underlying logical-level structure. This high-level query interface provides substantial cost savings to the applications development and maintenance process. Software development time is decre...
متن کاملMeasurement and Comparison of Industrial Infrastructure of SMEs among Iranian Provinces
The creation of small manufacturing enterprises is considered by many governments and donor agencies, as the key to economic and social development in countries regardless of development level. Furthermore, review of the literature show evidence that SMEs are understood as a source of technology development. At the same time they are vulnerable to a number of restrictions such as access to fina...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2003